Pandas Profiling Report

Dataset statistics

Number of variables	35
Number of observations	164386
Missing cells	1373638
Missing cells (%)	23.9%
Duplicate rows	22193
Duplicate rows (%)	13.5%
Total size in memory	45.1 MiB
Average record size in memory	288.0 B

Variable types

NUM	25
CAT	7
BOOL	2
DATE	1

Reproduction

Analysis started	2020-10-05 20:23:12.708192
Analysis finished	2020-10-05 20:29:19.201270
Duration	6 minutes and 6.49 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

Dataset has 22193 (13.5%) duplicate rows	Duplicates
`pressure3pm` is highly correlated with `pressure9am`	High correlation
`pressure9am` is highly correlated with `pressure3pm`	High correlation
`temp9am` is highly correlated with `mintemp`	High correlation
`mintemp` is highly correlated with `temp9am`	High correlation
`temp3pm` is highly correlated with `maxtemp`	High correlation
`maxtemp` is highly correlated with `temp3pm`	High correlation
`humidity` is highly correlated with `humidity3pm`	High correlation
`humidity3pm` is highly correlated with `humidity`	High correlation
`evaporation` has 74258 (45.2%) missing values	Missing
`sunshine` has 83779 (51.0%) missing values	Missing
`humidity9am` has 2034 (1.2%) missing values	Missing
`humidity3pm` has 5124 (3.1%) missing values	Missing
`pressure9am` has 16301 (9.9%) missing values	Missing
`pressure3pm` has 16273 (9.9%) missing values	Missing
`cloud9am` has 63507 (38.6%) missing values	Missing
`cloud3pm` has 68670 (41.8%) missing values	Missing
`temp3pm` has 4077 (2.5%) missing values	Missing
`humidity` has 5124 (3.1%) missing values	Missing
`wind_gustdir` has 127967 (77.8%) missing values	Missing
`wind_gustspeed` has 127960 (77.8%) missing values	Missing
`wind_dir9am` has 127454 (77.5%) missing values	Missing
`wind_dir3pm` has 125396 (76.3%) missing values	Missing
`wind_speed9am` has 125086 (76.1%) missing values	Missing
`wind_speed3pm` has 125058 (76.1%) missing values	Missing
`windgustdir` has 46997 (28.6%) missing values	Missing
`windgustspeed` has 46944 (28.6%) missing values	Missing
`winddir9am` has 48360 (29.4%) missing values	Missing
`winddir3pm` has 43825 (26.7%) missing values	Missing
`windspeed9am` has 40753 (24.8%) missing values	Missing
`windspeed3pm` has 42911 (26.1%) missing values	Missing
`rainfall` has 104117 (63.3%) zeros	Zeros
`sunshine` has 2553 (1.6%) zeros	Zeros
`cloud9am` has 9450 (5.7%) zeros	Zeros
`cloud3pm` has 5298 (3.2%) zeros	Zeros
`amountOfRain` has 105038 (63.9%) zeros	Zeros
`wind_speed9am` has 2351 (1.4%) zeros	Zeros
`windspeed9am` has 7570 (4.6%) zeros	Zeros

date
Date

Distinct count	3436
Unique (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Minimum	2007-01-01 00:11:00
Maximum	2017-01-31 00:05:00

Histogram

Histogram

location
Categorical

Distinct count	49
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Canberra	3877
Sydney	3798
Perth	3655
Darwin	3653
Hobart	3650
Other values (44)	145753

Common Values
Length

Value	Count	Frequency (%)
Canberra	3877	2.4%
Sydney	3798	2.3%
Perth	3655	2.2%
Darwin	3653	2.2%
Hobart	3650	2.2%
Brisbane	3618	2.2%
Adelaide	3549	2.2%
Bendigo	3491	2.1%
Townsville	3489	2.1%
Ballarat	3489	2.1%
Other values (39)	128117	77.9%

Length

Max length	16
Median length	8
Mean length	8.695095689
Min length	4

mintemp
Real number (ℝ)

HIGH CORRELATION

Distinct count	389
Unique (%)	0.2%
Missing	772
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%

Mean	12.166113535516523
Minimum	-8.5
Maximum	33.9
Zeros	177
Zeros (%)	0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	-8.5
5-th percentile	1.8
Q1	7.6
median	11.9
Q3	16.8
95-th percentile	23.1
Maximum	33.9
Range	42.4
Interquartile range (IQR)	9.2

Descriptive statistics

Standard deviation	6.40119073
Coefficient of variation (CV)	0.5261491857
Kurtosis	-0.4830438876
Mean	12.16611354
Median Absolute Deviation (MAD)	4.6
Skewness	0.04032331322
Sum	1990546.5
Variance	40.97524276

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
9.6	1035	0.6%
10.2	1028	0.6%
11	1024	0.6%
10.5	1013	0.6%
10	1011	0.6%
9	1010	0.6%
8.9	993	0.6%
12	992	0.6%
10.8	990	0.6%
10.4	987	0.6%
Other values (379)	153531	93.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-8.5	1	< 0.1%
-8.2	2	< 0.1%
-8	2	< 0.1%
-7.8	2	< 0.1%
-7.6	2	< 0.1%

Value	Count	Frequency (%)
33.9	1	< 0.1%
31.9	1	< 0.1%
31.8	1	< 0.1%
31.4	4	< 0.1%
31.2	1	< 0.1%

maxtemp
Real number (ℝ)

HIGH CORRELATION

Distinct count	505
Unique (%)	0.3%
Missing	397
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%

Mean	23.19011092207404
Minimum	-4.8
Maximum	48.1
Zeros	15
Zeros (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	-4.8
5-th percentile	12.8
Q1	17.9
median	22.6
Q3	28.2
95-th percentile	35.5
Maximum	48.1
Range	52.9
Interquartile range (IQR)	10.3

Descriptive statistics

Standard deviation	7.12029885
Coefficient of variation (CV)	0.3070403101
Kurtosis	-0.2356615366
Mean	23.19011092
Median Absolute Deviation (MAD)	5.1
Skewness	0.2333731942
Sum	3802923.1
Variance	50.69865571

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
20	1016	0.6%
19	960	0.6%
19.8	950	0.6%
20.4	943	0.6%
20.8	933	0.6%
21	929	0.6%
19.5	923	0.6%
18.9	922	0.6%
19.4	919	0.6%
20.2	914	0.6%
Other values (495)	154580	94.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4.8	2	< 0.1%
-4.1	1	< 0.1%
-3.8	1	< 0.1%
-3.7	1	< 0.1%
-3.2	1	< 0.1%

Value	Count	Frequency (%)
48.1	1	< 0.1%
47.3	3	< 0.1%
47	2	< 0.1%
46.9	2	< 0.1%
46.8	4	< 0.1%

rainfall
Real number (ℝ_≥0)

ZEROS

Distinct count	679
Unique (%)	0.4%
Missing	1619
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.3543218219909443
Minimum	0.0
Maximum	371.0
Zeros	104117
Zeros (%)	63.3%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.8
95-th percentile	13
Maximum	371
Range	371
Interquartile range (IQR)	0.8

Descriptive statistics

Standard deviation	8.417734503
Coefficient of variation (CV)	3.575439188
Kurtosis	172.8685562
Mean	2.354321822
Median Absolute Deviation (MAD)	0
Skewness	9.719707325
Sum	383205.9
Variance	70.85825416

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	104117	63.3%
0.2	10172	6.2%
0.4	4314	2.6%
0.6	2917	1.8%
0.8	2313	1.4%
1	2000	1.2%
1.2	1750	1.1%
1.4	1599	1.0%
1.6	1377	0.8%
1.8	1250	0.8%
Other values (669)	30958	18.8%
(Missing)	1619	1.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	104117	63.3%
0.1	197	0.1%
0.2	10172	6.2%
0.3	84	0.1%
0.4	4314	2.6%

Value	Count	Frequency (%)
371	1	< 0.1%
367.6	1	< 0.1%
278.4	1	< 0.1%
268.6	1	< 0.1%
247.2	1	< 0.1%

evaporation
Real number (ℝ_≥0)

MISSING

Distinct count	356
Unique (%)	0.4%
Missing	74258
Missing (%)	45.2%
Infinite	0
Infinite (%)	0.0%

Mean	5.49461876442393
Minimum	0.0
Maximum	145.0
Zeros	266
Zeros (%)	0.2%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2.6
median	4.8
Q3	7.4
95-th percentile	12
Maximum	145
Range	145
Interquartile range (IQR)	4.8

Descriptive statistics

Standard deviation	4.275539083
Coefficient of variation (CV)	0.7781320718
Kurtosis	55.45145963
Mean	5.494618764
Median Absolute Deviation (MAD)	2.4
Skewness	4.122042565
Sum	495219
Variance	18.28023445

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	3744	2.3%
8	2956	1.8%
2.2	2275	1.4%
2	2233	1.4%
2.4	2177	1.3%
2.6	2170	1.3%
3	2160	1.3%
3.4	2150	1.3%
1.8	2146	1.3%
3.2	2110	1.3%
Other values (346)	66007	40.2%
(Missing)	74258	45.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	266	0.2%
0.1	13	< 0.1%
0.2	527	0.3%
0.3	16	< 0.1%
0.4	820	0.5%

Value	Count	Frequency (%)
145	2	< 0.1%
86.2	2	< 0.1%
82.4	1	< 0.1%
81.2	1	< 0.1%
77.3	1	< 0.1%

sunshine
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct count	145
Unique (%)	0.2%
Missing	83779
Missing (%)	51.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.607071346161004
Minimum	0.0
Maximum	14.5
Zeros	2553
Zeros (%)	1.6%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.3
Q1	4.9
median	8.4
Q3	10.6
95-th percentile	12.8
Maximum	14.5
Range	14.5
Interquartile range (IQR)	5.7

Descriptive statistics

Standard deviation	3.778323829
Coefficient of variation (CV)	0.4966857358
Kurtosis	-0.8196559822
Mean	7.607071346
Median Absolute Deviation (MAD)	2.6
Skewness	-0.5002194816
Sum	613183.2
Variance	14.27573095

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	2553	1.6%
10.7	1160	0.7%
11	1153	0.7%
10.8	1138	0.7%
10.5	1109	0.7%
10.9	1099	0.7%
10.3	1077	0.7%
10.2	1059	0.6%
10	1057	0.6%
11.1	1043	0.6%
Other values (135)	68159	41.5%
(Missing)	83779	51.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2553	1.6%
0.1	573	0.3%
0.2	570	0.3%
0.3	453	0.3%
0.4	347	0.2%

Value	Count	Frequency (%)
14.5	1	< 0.1%
14.3	4	< 0.1%
14.2	2	< 0.1%
14.1	7	< 0.1%
14	16	< 0.1%

humidity9am
Real number (ℝ_≥0)

MISSING

Distinct count	101
Unique (%)	0.1%
Missing	2034
Missing (%)	1.2%
Infinite	0
Infinite (%)	0.0%

Mean	69.08449541736474
Minimum	0.0
Maximum	100.0
Zeros	1
Zeros (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	34
Q1	57
median	70
Q3	83
95-th percentile	98
Maximum	100
Range	100
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	18.99304951
Coefficient of variation (CV)	0.2749249219
Kurtosis	-0.05275203679
Mean	69.08449542
Median Absolute Deviation (MAD)	13
Skewness	-0.4796766061
Sum	11216006
Variance	360.7359295

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
99	3815	2.3%
70	3481	2.1%
100	3464	2.1%
65	3416	2.1%
68	3413	2.1%
69	3408	2.1%
71	3378	2.1%
66	3371	2.1%
72	3332	2.0%
67	3326	2.0%
Other values (91)	127948	77.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	5	< 0.1%
2	8	< 0.1%
3	10	< 0.1%
4	22	< 0.1%

Value	Count	Frequency (%)
100	3464	2.1%
99	3815	2.3%
98	2511	1.5%
97	2118	1.3%
96	1862	1.1%

humidity3pm
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct count	101
Unique (%)	0.1%
Missing	5124
Missing (%)	3.1%
Infinite	0
Infinite (%)	0.0%

Mean	51.66956336100262
Minimum	0.0
Maximum	100.0
Zeros	4
Zeros (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	17
Q1	37
median	52
Q3	66
95-th percentile	88
Maximum	100
Range	100
Interquartile range (IQR)	29

Descriptive statistics

Standard deviation	20.7609592
Coefficient of variation (CV)	0.4018024897
Kurtosis	-0.5074502112
Mean	51.66956336
Median Absolute Deviation (MAD)	14
Skewness	0.03766029493
Sum	8228998
Variance	431.017427

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
57	3130	1.9%
52	3122	1.9%
55	3094	1.9%
59	3031	1.8%
53	3031	1.8%
56	3009	1.8%
58	3006	1.8%
50	2973	1.8%
60	2969	1.8%
54	2963	1.8%
Other values (91)	128934	78.4%
(Missing)	5124	3.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4	< 0.1%
1	26	< 0.1%
2	35	< 0.1%
3	65	< 0.1%
4	118	0.1%

Value	Count	Frequency (%)
100	537	0.3%
99	492	0.3%
98	688	0.4%
97	461	0.3%
96	534	0.3%

pressure9am
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct count	546
Unique (%)	0.4%
Missing	16301
Missing (%)	9.9%
Infinite	0
Infinite (%)	0.0%

Mean	1017.6454556504711
Minimum	980.5
Maximum	1041.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	980.5
5-th percentile	1006.1
Q1	1012.9
median	1017.6
Q3	1022.4
95-th percentile	1029.5
Maximum	1041
Range	60.5
Interquartile range (IQR)	9.5

Descriptive statistics

Standard deviation	7.129290981
Coefficient of variation (CV)	0.007005672694
Kurtosis	0.2693896181
Mean	1017.645456
Median Absolute Deviation (MAD)	4.7
Skewness	-0.1128570668
Sum	150698027.3
Variance	50.82678989

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1016.4	924	0.6%
1017.9	908	0.6%
1017.3	886	0.5%
1018	883	0.5%
1018.7	881	0.5%
1015.9	871	0.5%
1015.5	866	0.5%
1016.3	866	0.5%
1017.8	864	0.5%
1015.7	862	0.5%
Other values (536)	139274	84.7%
(Missing)	16301	9.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
980.5	1	< 0.1%
982	2	< 0.1%
982.2	2	< 0.1%
982.3	2	< 0.1%
982.9	3	< 0.1%

Value	Count	Frequency (%)
1041	1	< 0.1%
1040.9	1	< 0.1%
1040.6	2	< 0.1%
1040.5	1	< 0.1%
1040.4	3	< 0.1%

pressure3pm
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct count	549
Unique (%)	0.4%
Missing	16273
Missing (%)	9.9%
Infinite	0
Infinite (%)	0.0%

Mean	1015.2453025190225
Minimum	977.1
Maximum	1039.6
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	977.1
5-th percentile	1004
Q1	1010.4
median	1015.2
Q3	1020
95-th percentile	1026.9
Maximum	1039.6
Range	62.5
Interquartile range (IQR)	9.6

Descriptive statistics

Standard deviation	7.05609818
Coefficient of variation (CV)	0.006950141175
Kurtosis	0.1551495431
Mean	1015.245303
Median Absolute Deviation (MAD)	4.8
Skewness	-0.05901271552
Sum	150371027.5
Variance	49.78852152

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1015.5	898	0.5%
1015.3	882	0.5%
1015.7	874	0.5%
1015.1	871	0.5%
1015.6	870	0.5%
1015.4	867	0.5%
1015.8	867	0.5%
1016	860	0.5%
1013.5	852	0.5%
1015.2	846	0.5%
Other values (539)	139426	84.8%
(Missing)	16273	9.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
977.1	2	< 0.1%
978.2	2	< 0.1%
979	1	< 0.1%
980.2	2	< 0.1%
981.2	1	< 0.1%

Value	Count	Frequency (%)
1039.6	1	< 0.1%
1038.9	1	< 0.1%
1038.5	1	< 0.1%
1038.4	1	< 0.1%
1038.2	1	< 0.1%

cloud9am
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct count	10
Unique (%)	< 0.1%
Missing	63507
Missing (%)	38.6%
Infinite	0
Infinite (%)	0.0%

Mean	4.505328165425906
Minimum	0.0
Maximum	9.0
Zeros	9450
Zeros (%)	5.7%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	5
Q3	7
95-th percentile	8
Maximum	9
Range	9
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	2.893437895
Coefficient of variation (CV)	0.6422257799
Kurtosis	-1.529387348
Mean	4.505328165
Median Absolute Deviation (MAD)	3
Skewness	-0.2526857912
Sum	454493
Variance	8.371982852

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
7	22256	13.5%
8	17743	10.8%
1	17419	10.6%
0	9450	5.7%
6	9086	5.5%
2	7254	4.4%
3	6558	4.0%
5	6178	3.8%
4	4933	3.0%
9	2	< 0.1%
(Missing)	63507	38.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9450	5.7%
1	17419	10.6%
2	7254	4.4%
3	6558	4.0%
4	4933	3.0%

Value	Count	Frequency (%)
9	2	< 0.1%
8	17743	10.8%
7	22256	13.5%
6	9086	5.5%
5	6178	3.8%

cloud3pm
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct count	10
Unique (%)	< 0.1%
Missing	68670
Missing (%)	41.8%
Infinite	0
Infinite (%)	0.0%

Mean	4.560992937439926
Minimum	0.0
Maximum	9.0
Zeros	5298
Zeros (%)	3.2%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	7
95-th percentile	8
Maximum	9
Range	9
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.731072494
Coefficient of variation (CV)	0.5987890206
Kurtosis	-1.455244411
Mean	4.560992937
Median Absolute Deviation (MAD)	2
Skewness	-0.2425796017
Sum	436560
Variance	7.458756968

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
7	20088	12.2%
1	16538	10.1%
8	15233	9.3%
6	9726	5.9%
2	8005	4.9%
3	7550	4.6%
5	7409	4.5%
4	5868	3.6%
0	5298	3.2%
9	1	< 0.1%
(Missing)	68670	41.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5298	3.2%
1	16538	10.1%
2	8005	4.9%
3	7550	4.6%
4	5868	3.6%

Value	Count	Frequency (%)
9	1	< 0.1%
8	15233	9.3%
7	20088	12.2%
6	9726	5.9%
5	7409	4.5%

temp9am
Real number (ℝ)

HIGH CORRELATION

Distinct count	440
Unique (%)	0.3%
Missing	976
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%

Mean	16.949419864145405
Minimum	-7.2
Maximum	40.2
Zeros	38
Zeros (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	-7.2
5-th percentile	6.9
Q1	12.2
median	16.6
Q3	21.5
95-th percentile	28.2
Maximum	40.2
Range	47.4
Interquartile range (IQR)	9.3

Descriptive statistics

Standard deviation	6.494966589
Coefficient of variation (CV)	0.383196985
Kurtosis	-0.3447351777
Mean	16.94941986
Median Absolute Deviation (MAD)	4.6
Skewness	0.1036326171
Sum	2769704.7
Variance	42.184591

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
13.8	1042	0.6%
14.8	1018	0.6%
16	1016	0.6%
17	1013	0.6%
14	995	0.6%
15	992	0.6%
16.6	985	0.6%
15.4	974	0.6%
16.5	972	0.6%
15.1	969	0.6%
Other values (430)	153434	93.3%
(Missing)	976	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-7.2	2	< 0.1%
-7	2	< 0.1%
-6.2	1	< 0.1%
-5.9	1	< 0.1%
-5.6	3	< 0.1%

Value	Count	Frequency (%)
40.2	1	< 0.1%
39.4	1	< 0.1%
39.1	1	< 0.1%
39	1	< 0.1%
38.9	1	< 0.1%

temp3pm
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct count	500
Unique (%)	0.3%
Missing	4077
Missing (%)	2.5%
Infinite	0
Infinite (%)	0.0%

Mean	21.63317218621537
Minimum	-5.4
Maximum	46.7
Zeros	17
Zeros (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	-5.4
5-th percentile	11.5
Q1	16.6
median	21.1
Q3	26.4
95-th percentile	33.6
Maximum	46.7
Range	52.1
Interquartile range (IQR)	9.8

Descriptive statistics

Standard deviation	6.932849064
Coefficient of variation (CV)	0.3204730681
Kurtosis	-0.1349960626
Mean	21.63317219
Median Absolute Deviation (MAD)	4.8
Skewness	0.2427139888
Sum	3467992.2
Variance	48.06439614

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
20	983	0.6%
18.4	983	0.6%
18.5	982	0.6%
19	968	0.6%
17.8	967	0.6%
19.3	951	0.6%
18	943	0.6%
18.6	935	0.6%
17	934	0.6%
19.4	932	0.6%
Other values (490)	150731	91.7%
(Missing)	4077	2.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-5.4	2	< 0.1%
-5.1	1	< 0.1%
-4.4	1	< 0.1%
-4.2	2	< 0.1%
-4.1	1	< 0.1%

Value	Count	Frequency (%)
46.7	2	< 0.1%
46.2	2	< 0.1%
46.1	3	< 0.1%
45.9	1	< 0.1%
45.8	2	< 0.1%

raintoday
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	1619
Missing (%)	1.0%
Memory size	1.3 MiB

No	126200
Yes	36567
(Missing)	1619

Frequency Table

Value	Count	Frequency (%)
No	126200	76.8%
Yes	36567	22.2%
(Missing)	1619	1.0%

amountOfRain
Real number (ℝ_≥0)

ZEROS

Distinct count	681
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.3632596449819325
Minimum	0.0
Maximum	371.0
Zeros	105038
Zeros (%)	63.9%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.8
95-th percentile	13
Maximum	371
Range	371
Interquartile range (IQR)	0.8

Descriptive statistics

Standard deviation	8.419366365
Coefficient of variation (CV)	3.562607428
Kurtosis	171.28584
Mean	2.363259645
Median Absolute Deviation (MAD)	0
Skewness	9.66526212
Sum	388486.8
Variance	70.88572998

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	105038	63.9%
0.2	10263	6.2%
0.4	4350	2.6%
0.6	2955	1.8%
0.8	2345	1.4%
1	2016	1.2%
1.2	1771	1.1%
1.4	1615	1.0%
1.6	1393	0.8%
1.8	1266	0.8%
Other values (671)	31374	19.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	105038	63.9%
0.1	200	0.1%
0.2	10263	6.2%
0.3	85	0.1%
0.4	4350	2.6%

Value	Count	Frequency (%)
371	1	< 0.1%
367.6	1	< 0.1%
278.4	1	< 0.1%
268.6	1	< 0.1%
247.2	1	< 0.1%

raintomorrow
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

No	127338
Yes	37048

Frequency Table

Value	Count	Frequency (%)
No	127338	77.5%
Yes	37048	22.5%

temp
Real number (ℝ)

Distinct count	7620
Unique (%)	4.6%
Missing	397
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%

Mean	28.470265632407173
Minimum	-3.76
Maximum	59.72
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	-3.76
5-th percentile	3.473824179
Q1	22.52
median	28.52
Q3	35.36
95-th percentile	44.36
Maximum	59.72
Range	63.48
Interquartile range (IQR)	12.84

Descriptive statistics

Standard deviation	10.22528483
Coefficient of variation (CV)	0.359156636
Kurtosis	0.4721549931
Mean	28.47026563
Median Absolute Deviation (MAD)	6.36
Skewness	-0.4141530851
Sum	4668810.391
Variance	104.5564499

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
26	972	0.6%
24.8	916	0.6%
25.76	914	0.6%
26.48	884	0.5%
24.68	883	0.5%
27.2	879	0.5%
26.96	878	0.5%
25.4	873	0.5%
25.88	872	0.5%
25.28	871	0.5%
Other values (7610)	155047	94.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-3.76	2	< 0.1%
-2.92	1	< 0.1%
-2.56	1	< 0.1%
-1.84	1	< 0.1%
-1.72	2	< 0.1%

Value	Count	Frequency (%)
59.72	1	< 0.1%
58.76	3	< 0.1%
58.4	2	< 0.1%
58.28	2	< 0.1%
58.16	4	< 0.1%

humidity
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct count	4163
Unique (%)	2.6%
Missing	5124
Missing (%)	3.1%
Infinite	0
Infinite (%)	0.0%

Mean	62.21218436422996
Minimum	2.0
Maximum	122.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	2
5-th percentile	16.4
Q1	44
median	63.2
Q3	80
95-th percentile	106.4
Maximum	122
Range	120
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	26.62052964
Coefficient of variation (CV)	0.4278989705
Kurtosis	-0.3860322964
Mean	62.21218436
Median Absolute Deviation (MAD)	18
Skewness	-0.1243788503
Sum	9908036.906
Variance	708.6525983

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
70.4	3042	1.9%
64.4	3030	1.8%
68	3011	1.8%
65.6	2939	1.8%
72.8	2935	1.8%
71.6	2918	1.8%
69.2	2909	1.8%
74	2880	1.8%
66.8	2869	1.7%
62	2869	1.7%
Other values (4153)	129860	79.0%
(Missing)	5124	3.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	4	< 0.1%
2.00028566	1	< 0.1%
2.000513414	1	< 0.1%
2.001065311	1	< 0.1%
2.001185981	1	< 0.1%

Value	Count	Frequency (%)
122	524	0.3%
120.8	478	0.3%
119.6	664	0.4%
118.4	452	0.3%
117.2	511	0.3%

precipitation3pm
Real number (ℝ_≥0)

Distinct count	27
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10.014611949922744
Minimum	0
Maximum	26
Zeros	17
Zeros (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	8
median	10
Q3	12
95-th percentile	15
Maximum	26
Range	26
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.174690898
Coefficient of variation (CV)	0.3170058824
Kurtosis	0.1043920325
Mean	10.01461195
Median Absolute Deviation (MAD)	2
Skewness	0.3205194297
Sum	1646262
Variance	10.0786623

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
9	20467	12.5%
10	20309	12.4%
11	18736	11.4%
8	18495	11.3%
12	15593	9.5%
7	14850	9.0%
13	12033	7.3%
6	10431	6.3%
14	8584	5.2%
5	6107	3.7%
Other values (17)	18781	11.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	17	< 0.1%
1	69	< 0.1%
2	370	0.2%
3	1271	0.8%
4	3073	1.9%

Value	Count	Frequency (%)
26	4	< 0.1%
25	5	< 0.1%
24	8	< 0.1%
23	37	< 0.1%
22	73	< 0.1%

precipitation9am
Real number (ℝ)

Distinct count	142193
Unique (%)	86.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	9.995437942353472
Minimum	-17.7393457403299
Maximum	32.4785898089529
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	-17.73934574
5-th percentile	1.763924092
Q1	6.64601366
median	9.996363073
Q3	13.37960089
95-th percentile	18.22206579
Maximum	32.47858981
Range	50.21793555
Interquartile range (IQR)	6.733587232

Descriptive statistics

Standard deviation	4.998239211
Coefficient of variation (CV)	0.5000520477
Kurtosis	0.003843435433
Mean	9.995437942
Median Absolute Deviation (MAD)	3.367733616
Skewness	-0.006724031779
Sum	1643110.062
Variance	24.98239521

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
6.310797784	2	< 0.1%
10.04917649	2	< 0.1%
15.41572682	2	< 0.1%
8.788187371	2	< 0.1%
8.439734389	2	< 0.1%
14.32456788	2	< 0.1%
15.11511415	2	< 0.1%
16.91088895	2	< 0.1%
11.91247309	2	< 0.1%
1.036628009	2	< 0.1%
Other values (142183)	164366	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-17.73934574	1	< 0.1%
-11.03540371	1	< 0.1%
-11.02393131	1	< 0.1%
-10.69808106	2	< 0.1%
-10.30285651	1	< 0.1%

Value	Count	Frequency (%)
32.47858981	1	< 0.1%
32.2100807	1	< 0.1%
30.35579697	1	< 0.1%
30.24384488	2	< 0.1%
30.17427309	1	< 0.1%

modelo_vigente
Real number (ℝ_≥0)

Distinct count	130381
Unique (%)	79.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.2302066959205493
Minimum	0.0
Maximum	0.9994
Zeros	471
Zeros (%)	0.3%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.004595059479
Q1	0.03225130191
median	0.1083058078
Q3	0.3374927775
95-th percentile	0.8478924242
Maximum	0.9994
Range	0.9994
Interquartile range (IQR)	0.3052414756

Descriptive statistics

Standard deviation	0.2691578395
Coefficient of variation (CV)	1.169200741
Kurtosis	0.5749034484
Mean	0.2302066959
Median Absolute Deviation (MAD)	0.09300930289
Skewness	1.326379389
Sum	37842.75792
Variance	0.07244594256

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	471	0.3%
0.001	94	0.1%
0.0006666666667	73	< 0.1%
0.0004	69	< 0.1%
0.0005	67	< 0.1%
0.002	63	< 0.1%
0.0002	60	< 0.1%
0.0002222222222	59	< 0.1%
0.0003333333333	57	< 0.1%
0.00025	50	< 0.1%
Other values (130371)	163323	99.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	471	0.3%
6.600660066e-06	3	< 0.1%
7.989347537e-06	36	< 0.1%
1.075268817e-05	1	< 0.1%
1.578947368e-05	1	< 0.1%

Value	Count	Frequency (%)
0.9994	1	< 0.1%
0.9992698413	1	< 0.1%
0.9991309524	1	< 0.1%
0.9983333333	1	< 0.1%
0.9980730159	1	< 0.1%

wind_gustdir
Categorical

MISSING

Distinct count	16
Unique (%)	< 0.1%
Missing	127967
Missing (%)	77.8%
Memory size	1.3 MiB

SE	2625
SW	2542
W	2529
S	2522
N	2470
Other values (11)	23731

Common Values
Length

Value	Count	Frequency (%)
SE	2625	1.6%
SW	2542	1.5%
W	2529	1.5%
S	2522	1.5%
N	2470	1.5%
SSE	2446	1.5%
WSW	2434	1.5%
E	2424	1.5%
SSW	2298	1.4%
WNW	2196	1.3%
Other values (6)	11933	7.3%
(Missing)	127967	77.8%

Length

Max length	3
Median length	3
Mean length	2.822563965
Min length	1

wind_gustspeed
Real number (ℝ_≥0)

MISSING

Distinct count	63
Unique (%)	0.2%
Missing	127960
Missing (%)	77.8%
Infinite	0
Infinite (%)	0.0%

Mean	40.38744303519464
Minimum	7.0
Maximum	135.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	7
5-th percentile	22
Q1	31
median	39
Q3	48
95-th percentile	65
Maximum	135
Range	128
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	13.53278336
Coefficient of variation (CV)	0.3350740316
Kurtosis	1.625654633
Mean	40.38744304
Median Absolute Deviation (MAD)	8
Skewness	0.9130138439
Sum	1471153
Variance	183.1362256

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
35	2498	1.5%
39	2448	1.5%
31	2279	1.4%
33	2180	1.3%
37	2143	1.3%
41	2090	1.3%
30	1855	1.1%
43	1829	1.1%
28	1687	1.0%
44	1534	0.9%
Other values (53)	15883	9.7%
(Missing)	127960	77.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	4	< 0.1%
9	14	< 0.1%
11	27	< 0.1%
13	126	0.1%
15	190	0.1%

Value	Count	Frequency (%)
135	2	< 0.1%
126	2	< 0.1%
124	1	< 0.1%
120	1	< 0.1%
117	1	< 0.1%

wind_dir9am
Categorical

MISSING

Distinct count	16
Unique (%)	< 0.1%
Missing	127454
Missing (%)	77.5%
Memory size	1.3 MiB

N	3113
SE	2663
E	2633
SSE	2538
W	2367
Other values (11)	23618

Common Values
Length

Value	Count	Frequency (%)
N	3113	1.9%
SE	2663	1.6%
E	2633	1.6%
SSE	2538	1.5%
W	2367	1.4%
S	2350	1.4%
NW	2282	1.4%
ENE	2280	1.4%
SW	2265	1.4%
NNE	2197	1.3%
Other values (6)	12244	7.4%
(Missing)	127454	77.5%

Length

Max length	3
Median length	3
Mean length	2.815720317
Min length	1

wind_dir3pm
Categorical

MISSING

Distinct count	16
Unique (%)	< 0.1%
Missing	125396
Missing (%)	76.3%
Memory size	1.3 MiB

SE	3244
S	2706
W	2656
SW	2643
WSW	2637
Other values (11)	25104

Common Values
Length

Value	Count	Frequency (%)
SE	3244	2.0%
S	2706	1.6%
W	2656	1.6%
SW	2643	1.6%
WSW	2637	1.6%
SSE	2611	1.6%
E	2454	1.5%
WNW	2417	1.5%
N	2404	1.5%
ESE	2354	1.4%
Other values (6)	12864	7.8%
(Missing)	125396	76.3%

Length

Max length	3
Median length	3
Mean length	2.811395131
Min length	1

wind_speed9am
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct count	39
Unique (%)	0.1%
Missing	125086
Missing (%)	76.1%
Infinite	0
Infinite (%)	0.0%

Mean	14.145648854961832
Minimum	0.0
Maximum	87.0
Zeros	2351
Zeros (%)	1.4%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	7
median	13
Q3	19
95-th percentile	30
Maximum	87
Range	87
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	8.928349253
Coefficient of variation (CV)	0.6311728324
Kurtosis	1.188131273
Mean	14.14564885
Median Absolute Deviation (MAD)	6
Skewness	0.7820819194
Sum	555924
Variance	79.71542039

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
9	3693	2.2%
13	3558	2.2%
11	3245	2.0%
7	3007	1.8%
15	2991	1.8%
17	2885	1.8%
6	2530	1.5%
19	2463	1.5%
0	2351	1.4%
20	2203	1.3%
Other values (29)	10374	6.3%
(Missing)	125086	76.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2351	1.4%
2	1213	0.7%
4	1581	1.0%
6	2530	1.5%
7	3007	1.8%

Value	Count	Frequency (%)
87	1	< 0.1%
83	1	< 0.1%
74	3	< 0.1%
67	1	< 0.1%
65	2	< 0.1%

wind_speed3pm
Real number (ℝ_≥0)

MISSING

Distinct count	41
Unique (%)	0.1%
Missing	125058
Missing (%)	76.1%
Infinite	0
Infinite (%)	0.0%

Mean	18.948916802278276
Minimum	0.0
Maximum	87.0
Zeros	318
Zeros (%)	0.2%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	13
median	19
Q3	24
95-th percentile	35
Maximum	87
Range	87
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	8.774876547
Coefficient of variation (CV)	0.4630806414
Kurtosis	0.7977314
Mean	18.9489168
Median Absolute Deviation (MAD)	6
Skewness	0.5884125002
Sum	745223
Variance	76.99845841

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
17	3437	2.1%
13	3340	2.0%
20	3291	2.0%
15	3185	1.9%
19	3174	1.9%
11	2611	1.6%
24	2563	1.6%
22	2531	1.5%
9	2504	1.5%
26	1896	1.2%
Other values (31)	10796	6.6%
(Missing)	125058	76.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	318	0.2%
2	271	0.2%
4	558	0.3%
6	975	0.6%
7	1561	0.9%

Value	Count	Frequency (%)
87	1	< 0.1%
83	1	< 0.1%
76	2	< 0.1%
69	1	< 0.1%
67	1	< 0.1%

windgustdir
Categorical

MISSING

Distinct count	16
Unique (%)	< 0.1%
Missing	46997
Missing (%)	28.6%
Memory size	1.3 MiB

W	8922
N	8043
SE	8029
E	8022
WSW	7886
Other values (11)	76487

Common Values
Length

Value	Count	Frequency (%)
W	8922	5.4%
N	8043	4.9%
SE	8029	4.9%
E	8022	4.9%
WSW	7886	4.8%
SSE	7793	4.7%
SSW	7780	4.7%
S	7647	4.7%
SW	7616	4.6%
NW	7294	4.4%
Other values (6)	38357	23.3%
(Missing)	46997	28.6%

Length

Max length	3
Median length	3
Mean length	2.425875683
Min length	1

windgustspeed
Real number (ℝ_≥0)

MISSING

Distinct count	66
Unique (%)	0.1%
Missing	46944
Missing (%)	28.6%
Infinite	0
Infinite (%)	0.0%

Mean	39.701691047495785
Minimum	6.0
Maximum	135.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	6
5-th percentile	20
Q1	30
median	37
Q3	48
95-th percentile	65
Maximum	135
Range	129
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	13.64432793
Coefficient of variation (CV)	0.3436712031
Kurtosis	1.316042277
Mean	39.70169105
Median Absolute Deviation (MAD)	7
Skewness	0.8614914618
Sum	4662646
Variance	186.1676846

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
35	7967	4.8%
39	7448	4.5%
31	7385	4.5%
37	7021	4.3%
33	6854	4.2%
41	6218	3.8%
30	6205	3.8%
28	5756	3.5%
43	5624	3.4%
46	4628	2.8%
Other values (56)	52336	31.8%
(Missing)	46944	28.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	1	< 0.1%
7	15	< 0.1%
9	95	0.1%
11	197	0.1%
13	512	0.3%

Value	Count	Frequency (%)
135	1	< 0.1%
130	1	< 0.1%
124	1	< 0.1%
122	2	< 0.1%
120	2	< 0.1%

winddir9am
Categorical

MISSING

Distinct count	16
Unique (%)	< 0.1%
Missing	48360
Missing (%)	29.4%
Memory size	1.3 MiB

N	10181
SE	7840
E	7764
NW	7757
SSE	7751
Other values (11)	74733

Common Values
Length

Value	Count	Frequency (%)
N	10181	6.2%
SE	7840	4.8%
E	7764	4.7%
NW	7757	4.7%
SSE	7751	4.7%
S	7313	4.4%
SW	7297	4.4%
W	7206	4.4%
NNE	7081	4.3%
NNW	7016	4.3%
Other values (6)	38820	23.6%
(Missing)	48360	29.4%

Length

Max length	3
Median length	3
Mean length	2.426258927
Min length	1

winddir3pm
Categorical

MISSING

Distinct count	16
Unique (%)	< 0.1%
Missing	43825
Missing (%)	26.7%
Memory size	1.3 MiB

W	8867
SE	8775
S	8265
WSW	8092
SW	7987
Other values (11)	78575

Common Values
Length

Value	Count	Frequency (%)
W	8867	5.4%
SE	8775	5.3%
S	8265	5.0%
WSW	8092	4.9%
SW	7987	4.9%
SSE	7828	4.8%
N	7700	4.7%
WNW	7673	4.7%
NW	7516	4.6%
ESE	7269	4.4%
Other values (6)	40589	24.7%
(Missing)	43825	26.7%

Length

Max length	3
Median length	3
Mean length	2.421629579
Min length	1

windspeed9am
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct count	42
Unique (%)	< 0.1%
Missing	40753
Missing (%)	24.8%
Infinite	0
Infinite (%)	0.0%

Mean	13.9012399602048
Minimum	0.0
Maximum	130.0
Zeros	7570
Zeros (%)	4.6%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	7
median	13
Q3	19
95-th percentile	30
Maximum	130
Range	130
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	8.848133877
Coefficient of variation (CV)	0.6364996146
Kurtosis	1.45263166
Mean	13.90123996
Median Absolute Deviation (MAD)	6
Skewness	0.7919918891
Sum	1718652
Variance	78.28947311

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
9	12007	7.3%
13	11361	6.9%
11	10110	6.2%
17	9391	5.7%
7	9262	5.6%
15	9029	5.5%
6	7937	4.8%
0	7570	4.6%
19	7420	4.5%
20	6920	4.2%
Other values (32)	32626	19.8%
(Missing)	40753	24.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7570	4.6%
2	4108	2.5%
4	5665	3.4%
6	7937	4.8%
7	9262	5.6%

Value	Count	Frequency (%)
130	2	< 0.1%
87	1	< 0.1%
74	2	< 0.1%
72	1	< 0.1%
69	2	< 0.1%

windspeed3pm
Real number (ℝ_≥0)

MISSING

Distinct count	41
Unique (%)	< 0.1%
Missing	42911
Missing (%)	26.1%
Infinite	0
Infinite (%)	0.0%

Mean	18.4517061123688
Minimum	0.0
Maximum	83.0
Zeros	882
Zeros (%)	0.5%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	13
median	17
Q3	24
95-th percentile	33
Maximum	83
Range	83
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	8.778299542
Coefficient of variation (CV)	0.4757445999
Kurtosis	0.7780722111
Mean	18.45170611
Median Absolute Deviation (MAD)	6
Skewness	0.6609954925
Sum	2241421
Variance	77.05854285

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
13	11039	6.7%
17	10753	6.5%
20	10009	6.1%
15	9908	6.0%
19	9494	5.8%
11	8895	5.4%
9	8685	5.3%
24	7541	4.6%
22	7079	4.3%
28	5391	3.3%
Other values (31)	32681	19.9%
(Missing)	42911	26.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	882	0.5%
2	894	0.5%
4	1962	1.2%
6	3406	2.1%
7	5213	3.2%

Value	Count	Frequency (%)
83	1	< 0.1%
78	1	< 0.1%
74	1	< 0.1%
72	2	< 0.1%
69	2	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	date	location	mintemp	maxtemp	rainfall	evaporation	sunshine	humidity9am	humidity3pm	pressure9am	pressure3pm	cloud9am	cloud3pm	temp9am	temp3pm	raintoday	amountOfRain	raintomorrow	temp	humidity	precipitation3pm	precipitation9am	modelo_vigente	wind_gustdir	wind_gustspeed	wind_dir9am	wind_dir3pm	wind_speed9am	wind_speed3pm	windgustdir	windgustspeed	winddir9am	winddir3pm	windspeed9am	windspeed3pm
0	2008-01-01 00:12:00	Albury	13.4	22.9	0.6	NaN	NaN	71.0	22.0	1007.7	1007.1	8.0	NaN	16.9	21.8	No	0.0	No	29.48	28.400000	12	5.115360	0.089825	W	44.0	W	WNW	20.0	24.0	NaN	NaN	NaN	NaN	NaN	NaN
1	2008-01-02 00:12:00	Albury	7.4	25.1	0.0	NaN	NaN	44.0	25.0	1010.6	1007.8	NaN	NaN	17.2	24.3	No	0.0	No	32.12	2.208569	10	21.497100	0.023477	WNW	44.0	NNW	WSW	4.0	22.0	NaN	NaN	NaN	NaN	NaN	NaN
2	2008-01-03 00:12:00	Albury	12.9	25.7	0.0	NaN	NaN	38.0	30.0	1007.6	1008.7	NaN	2.0	21.0	23.2	No	0.0	No	32.84	38.000000	17	20.782859	0.027580	WSW	46.0	W	WSW	19.0	26.0	NaN	NaN	NaN	NaN	NaN	NaN
3	2008-01-04 00:12:00	Albury	9.2	28.0	0.0	NaN	NaN	45.0	16.0	1017.6	1012.8	NaN	NaN	18.1	26.5	No	1.0	No	35.60	21.200000	8	12.028646	0.023962	NE	24.0	SE	E	11.0	9.0	NaN	NaN	NaN	NaN	NaN	NaN
4	2008-01-05 00:12:00	Albury	17.5	32.3	1.0	NaN	NaN	82.0	33.0	1010.8	1006.0	7.0	8.0	17.8	29.7	No	0.2	No	40.76	41.600000	9	11.883546	0.220164	W	41.0	ENE	NW	7.0	20.0	NaN	NaN	NaN	NaN	NaN	NaN
5	2008-01-06 00:12:00	Albury	14.6	29.7	0.2	NaN	NaN	55.0	23.0	1009.2	1005.4	NaN	NaN	20.6	28.9	No	0.0	No	37.64	29.600000	8	17.320994	0.056883	WNW	56.0	W	W	19.0	24.0	NaN	NaN	NaN	NaN	NaN	NaN
6	2008-01-07 00:12:00	Albury	14.3	25.0	0.0	NaN	NaN	49.0	19.0	1009.6	1008.2	1.0	NaN	18.1	24.6	No	0.0	No	32.00	24.800000	8	19.791271	0.030004	W	50.0	SW	W	20.0	24.0	NaN	NaN	NaN	NaN	NaN	NaN
7	2008-01-08 00:12:00	Albury	7.7	26.7	0.0	NaN	NaN	48.0	19.0	1013.4	1010.1	NaN	NaN	16.3	25.5	No	0.0	No	34.04	24.800000	7	7.207085	0.023000	W	35.0	SSE	W	6.0	17.0	NaN	NaN	NaN	NaN	NaN	NaN
8	2008-01-09 00:12:00	Albury	9.7	31.9	0.0	NaN	NaN	42.0	9.0	1008.9	1003.6	NaN	NaN	18.3	30.2	No	1.4	Yes	40.28	12.800000	19	1.540702	0.414649	NNW	80.0	SE	NW	7.0	28.0	NaN	NaN	NaN	NaN	NaN	NaN
9	2008-01-10 00:12:00	Albury	13.1	30.1	1.4	NaN	NaN	58.0	27.0	1007.0	1005.7	NaN	NaN	20.1	28.2	Yes	0.0	No	38.12	34.400000	7	8.259833	0.064945	W	28.0	S	SSE	15.0	11.0	NaN	NaN	NaN	NaN	NaN	NaN

Last rows

	date	location	mintemp	maxtemp	evaporation	sunshine	humidity9am	humidity3pm	pressure9am	pressure3pm	cloud9am	cloud3pm	temp9am	temp3pm	raintoday	raintomorrow	temp	humidity	precipitation3pm	precipitation9am	modelo_vigente	wind_gustdir	wind_gustspeed	wind_dir9am	wind_dir3pm	wind_speed9am	wind_speed3pm	windgustdir	windgustspeed	winddir9am	winddir3pm	windspeed9am	windspeed3pm
164376	2017-01-20 00:06:00	Uluru	3.5	21.8	NaN	NaN	59.0	27.0	1024.7	1021.2	NaN	NaN	9.4	20.9	No	No	28.16	34.4	12	5.848681	0.002556	NaN	NaN	NaN	NaN	NaN	NaN	E	31.0	ESE	E	15.0	13.0
164377	2017-01-20 00:06:00	Uluru	3.5	21.8	NaN	NaN	59.0	27.0	1024.7	1021.2	NaN	NaN	9.4	20.9	No	No	28.16	34.4	12	5.848681	0.002556	NaN	NaN	NaN	NaN	NaN	NaN	E	31.0	ESE	E	15.0	13.0
164378	2017-01-21 00:06:00	Uluru	2.8	23.4	NaN	NaN	51.0	24.0	1024.6	1020.3	NaN	NaN	10.1	22.4	No	No	30.08	30.8	10	6.653879	0.002053	NaN	NaN	NaN	NaN	NaN	NaN	E	31.0	SE	ENE	13.0	11.0
164379	2017-01-21 00:06:00	Uluru	2.8	23.4	NaN	NaN	51.0	24.0	1024.6	1020.3	NaN	NaN	10.1	22.4	No	No	30.08	30.8	10	6.653879	0.002053	NaN	NaN	NaN	NaN	NaN	NaN	E	31.0	SE	ENE	13.0	11.0
164380	2017-01-22 00:06:00	Uluru	3.6	25.3	NaN	NaN	56.0	21.0	1023.5	1019.1	NaN	NaN	10.9	24.5	No	No	32.36	27.2	9	19.715976	0.023350	NaN	NaN	NaN	NaN	NaN	NaN	NNW	22.0	SE	N	13.0	9.0
164381	2017-01-22 00:06:00	Uluru	3.6	25.3	NaN	NaN	56.0	21.0	1023.5	1019.1	NaN	NaN	10.9	24.5	No	No	32.36	27.2	9	19.715976	0.023350	NaN	NaN	NaN	NaN	NaN	NaN	NNW	22.0	SE	N	13.0	9.0
164382	2017-01-23 00:06:00	Uluru	5.4	26.9	NaN	NaN	53.0	24.0	1021.0	1016.8	NaN	NaN	12.5	26.1	No	No	34.28	30.8	12	0.985551	0.007195	NaN	NaN	NaN	NaN	NaN	NaN	N	37.0	SE	WNW	9.0	9.0
164383	2017-01-23 00:06:00	Uluru	5.4	26.9	NaN	NaN	53.0	24.0	1021.0	1016.8	NaN	NaN	12.5	26.1	No	No	34.28	30.8	12	0.985551	0.007195	NaN	NaN	NaN	NaN	NaN	NaN	N	37.0	SE	WNW	9.0	9.0
164384	2017-01-24 00:06:00	Uluru	7.8	27.0	NaN	NaN	51.0	24.0	1019.4	1016.5	3.0	2.0	15.1	26.0	No	No	34.40	30.8	15	4.381481	0.018811	NaN	NaN	NaN	NaN	NaN	NaN	SE	28.0	SSE	N	13.0	7.0
164385	2017-01-24 00:06:00	Uluru	7.8	27.0	NaN	NaN	51.0	24.0	1019.4	1016.5	3.0	2.0	15.1	26.0	No	No	34.40	30.8	15	4.381481	0.018811	NaN	NaN	NaN	NaN	NaN	NaN	SE	28.0	SSE	N	13.0	7.0

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows